CREATE EXTERNAL TABLE jms_ods.t_del_reback_transfer_info (
        WAYBILL_NO string comment'运单号',
        APPLY_TYPE_CODE bigint comment'申请类型编码',
        APPLY_TIME timestamp comment'申请时间',
        OPERATE_TIME timestamp comment'删除时间'
) comment '退转件删除表'
PARTITIONED BY (dt STRING COMMENT '分区-删除时间')
STORED AS PARQUET
LOCATION '/dw/hive/jms_ods.db/external/t_del_reback_transfer_info';